Manage Your Remote Database via LightSail’s phpMyAdmin Using PuTTY on Windows 🖥️

Prerequisites:

• LightSail Instance
• PuTTY on Windows

Steps:

1. Install PuTTY:

   • Download and install from PuTTY’s official site.

2. Generate Private Key:

   • Open PuTTYgen.
   • Download the default key from your LightSail instance.
   • Load the key in PuTTYgen and save the private key (e.g., “mykey”).

3. Get phpMyAdmin Credentials:

   • Connect to your LightSail instance using SSH.
   • In the SSH terminal, navigate to the WordPress directory:

     cd stack/wordpress

   • Display the wp-config.php file:

     cat wp-config.php

   • Copy the database username and password.

4. Configure PuTTY:

   • Session: Enter LightSail’s IP and port 22, then save the session.
   • SSH > Auth: Browse and select your private key.
   • Tunnels: Add a new tunnel with:
     • Source Port: 8888
     • Destination: localhost:80
   • Data: Set auto-login username to “bitnami”.

5. Open Terminal:

   • In the “Session” category, click “Open” and log in with “bitnami”.

6. Access phpMyAdmin:

   • Open your browser and go to:

     http://localhost:8888/phpmyadmin/index.php

7. Log into phpMyAdmin:

   • Use the copied username and password to log in 🗝️.

8. You’re In:

   • 🎉 Congratulations, you’re now connected!